﻿CREATE TABLE [dbo].[IssueType] (
    [IssueTypeId] INT           NOT NULL,
    [CategoryId]  INT           NOT NULL,
    [ScopeId]     INT           NOT NULL,
    [Severity]    INT           NULL,
    [Description] VARCHAR (4000) NULL,
    [Fixable] BIT NULL, 
    [Enabled] BIT NULL, 
    CONSTRAINT [PK_IssueType] PRIMARY KEY CLUSTERED ([IssueTypeId] ASC),
    CONSTRAINT [FK_IssueType_Category] FOREIGN KEY ([CategoryId]) REFERENCES [dbo].[Category] ([CategoryId]),
    CONSTRAINT [FK_IssueType_Scope] FOREIGN KEY ([ScopeId]) REFERENCES [dbo].[Scope] ([ScopeId])
);

